Practice Set 3
We'll cover the following
Practice Set 3#
The database relationship model is reprinted below.
Connect to the terminal below by clicking in the widget. Once connected, the command line prompt will show up. Enter or copy and paste the command ./DataJek/Lessons/quiz.sh and wait for the MySQL prompt to start-up.
Write and execute queries for the following questions:
- Write a query to display all those movie titles whose budget is greater than the average budget of all the movies.
Expected Result:
| Name |
|---|
| movie 1 |
| movie 2 |
| … |
| … |
| movie n |
- Find all those actors who don’t have any digital media presence using a right join statement.
Expected Result:
| Actors_With_No_Online_Presence |
|---|
| actor 1 |
| actor 2 |
| … |
| … |
| actor n |
- Can you rewrite the previous query without a join and using EXISTS operator?
Expected Result:
| Actors_With_No_Online_Presence |
|---|
| actor 1 |
| actor 2 |
| … |
| … |
| actor n |
-
Write a query to print the name of the fifth highest grossing movie at the box office.
Expected Result:
| Name | Collection_In_Millions |
|---|---|
| Fifth highest Grossing Movie Name | collection amount |
- Find those movies, whose cast latest activity on social media occurred between the span of 5 days before and 5 days after the release date.
Expected Result:
| Actors_Posting_Online_Within_Five_Days_Of_Movie_Release |
|---|
| actor 1 |
| actor 2 |
| … |
| … |
| actor n |
Solution Practice Set 2
Solution Practice Set 3
Mark as Completed
Report an Issue
